USE [IntelligentStackerSystem]

/****** Object:  Table [dbo].[User]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[User](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Account] [varchar](50) NULL,
	[UserName] [varchar](50) NULL,
	[Password] [varchar](255) NULL,
	[Role] [varchar](255) NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

SET IDENTITY_INSERT [dbo].[User] ON
INSERT [dbo].[User] ([Id], [Account], [UserName], [Password], [Role]) VALUES (1, N'admin', N'管理员', N'HcyffcqblQqxasgKZ8c9mQ==', N'system')
INSERT [dbo].[User] ([Id], [Account], [UserName], [Password], [Role]) VALUES (2, N'user', N'普通用户', N'HcyffcqblQqxasgKZ8c9mQ==', N'guest')
SET IDENTITY_INSERT [dbo].[User] OFF
/****** Object:  Table [dbo].[TaskInfo]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[TaskInfo](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TaskDesc] [varchar](100) NULL,
	[CreateTime] [datetime2](7) NULL,
	[StartTime] [datetime2](7) NULL,
	[EndTime] [datetime2](7) NULL,
	[StartPoint] [varchar](50) NULL,
	[EndPoint] [varchar](50) NULL,
	[Status] [varchar](255) NULL,
	[OrderNo] [int] NULL,
	[IsDelete] [int] NULL,
 CONSTRAINT [PK_TaskInfo] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'Id'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'TaskDesc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'CreateTime'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'StartTime'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'EndTime'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'起点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'StartPoint'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'终点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'EndPoint'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务状态 1：等待，2：执行中，3：已完成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'Status'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务排序 只有等待中的任务才有排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'OrderNo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除 1=删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskInfo', @level2type=N'COLUMN',@level2name=N'IsDelete'

/****** Object:  Table [dbo].[TagInfo]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[TagInfo](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[EquipmentName] [varchar](30) NULL,
	[OrderNo] [int] NULL,
	[TagDesc] [varchar](100) NULL,
	[Address] [varchar](255) NULL,
	[ValueType] [varchar](20) NULL,
	[ReadOrWrite] [bit] NULL,
	[Remark] [varchar](255) NULL,
	[IsEnable] [bit] NULL,
	[Type] [int] NULL,
	[Point] [varchar](100) NULL,
 CONSTRAINT [PK_TagInfo] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_TagInfo] UNIQUE NONCLUSTERED 
(
	[TagDesc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'Id'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签所属设备：堆垛机，解垛机，炉组，加料车' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'EquipmentName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签排序序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'OrderNo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签含义' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'TagDesc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'Address'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签值数据类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'ValueType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True是只读，False是可写' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'ReadOrWrite'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标签的说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'Remark'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否可用：true是启用，false是不启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'IsEnable'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别：1是普通标签，2是任务标签，3是加料车任务反馈标签' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TagInfo', @level2type=N'COLUMN',@level2name=N'Type'

SET IDENTITY_INSERT [dbo].[TagInfo] ON
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (1, N'堆垛机', 10, N'1#隔条仓为空', N'DB2.0.0', N'Bool', 1, N'', 1, 1, N'1#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (2, N'堆垛机', 20, N'1#隔条仓层数', N'DB2.2.0', N'DInt', 1, N'', 1, 1, N'1#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (3, N'堆垛机', 30, N'2#隔条仓为空', N'DB2.6.0', N'Bool', 1, N'', 1, 1, N'2#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (4, N'堆垛机', 40, N'2#隔条仓层数', N'DB2.8.0', N'DInt', 1, N'', 1, 1, N'2#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (5, N'堆垛机', 50, N'1#堆垛位满', N'DB2.12.0', N'Bool', 1, N'', 1, 1, N'1#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (6, N'堆垛机', 60, N'1#铝垛堆叠层数', N'DB2.14.0', N'DInt', 1, N'', 1, 1, N'1#铝垛')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (7, N'堆垛机', 70, N'2#堆垛位满', N'DB2.18.0', N'Bool', 1, N'', 1, 1, N'2#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (8, N'堆垛机', 80, N'2#铝垛堆叠层数', N'DB2.20.0', N'DInt', 1, N'', 1, 1, N'2#铝垛')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (9, N'堆垛机', 90, N'隔条总仓空', N'DB2.28.0', N'Bool', 1, N'', 1, 1, N'隔条总仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (10, N'堆垛机', 100, N'隔条总仓隔条层数', N'DB2.30.0', N'DInt', 1, N'', 1, 1, N'隔条总仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (11, N'炉组', 110, N'1#均质炉有料', N'DB2.384.0', N'Bool', 1, N'', 1, 1, N'1#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (13, N'炉组', 130, N'1#均质炉加热完成', N'DB2.384.6', N'Bool', 1, N'', 1, 1, N'1#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (14, N'炉组', 140, N'2#均质炉有料', N'DB2.384.1', N'Bool', 1, N'', 1, 1, N'1#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (16, N'炉组', 160, N'2#均质炉加热完成', N'DB2.384.7', N'Bool', 1, N'', 1, 1, N'2#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (17, N'炉组', 170, N'1#冷却室有料', N'DB2.384.4', N'Bool', 1, N'', 1, 1, N'2#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (19, N'炉组', 190, N'1#冷却室冷却完成', N'DB2.385.2', N'Bool', 1, N'', 1, 1, N'1#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (20, N'炉组', 200, N'3#均质炉有料', N'DB2.384.2', N'Bool', 1, N'', 1, 1, N'3#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (22, N'炉组', 220, N'3#均质炉加热完成', N'DB2.385.0', N'Bool', 1, N'', 1, 1, N'3#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (23, N'炉组', 230, N'4#均质炉有料', N'DB2.384.3', N'Bool', 1, N'', 1, 1, N'4#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (25, N'炉组', 250, N'4#均质炉加热完成', N'DB2.385.1', N'Bool', 1, N'', 1, 1, N'4#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (26, N'炉组', 260, N'2#冷却室有料', N'DB2.384.5', N'Bool', 1, N'', 1, 1, N'2#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (28, N'炉组', 280, N'2#冷却室冷却完成', N'DB2.385.3', N'Bool', 1, N'', 1, 1, N'2#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (29, N'解垛机', 290, N'1#解垛位空垛', N'DB2.34.3', N'Bool', 1, N'', 1, 1, N'1#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (30, N'解垛机', 300, N'1#解垛位仅剩隔条', N'DB2.34.4', N'Bool', 1, N'', 1, 1, N'1#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (31, N'解垛机', 310, N'2#解垛位空垛', N'DB2.34.5', N'Bool', 1, N'', 1, 1, N'2#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (32, N'解垛机', 320, N'2#解垛位仅剩隔条', N'DB2.34.6', N'Bool', 1, N'', 1, 1, N'2#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (33, N'解垛机', 330, N'3#解垛位空垛', N'DB2.34.7', N'Bool', 1, N'', 1, 1, N'3#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (34, N'解垛机', 340, N'3#解垛位仅剩隔条', N'DB2.35.0', N'Bool', 1, N'', 1, 1, N'3#解垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (35, N'解垛机', 350, N'3#隔条仓满', N'DB2.35.1', N'Bool', 1, N'', 1, 1, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (36, N'解垛机', 360, N'3#隔条仓空', N'DB2.35.2', N'Bool', 1, N'', 1, 1, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (37, N'解垛机', 370, N'3#隔条仓层数', N'DB2.36.0', N'DInt', 1, N'', 1, 1, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (38, N'加料车', 380, N'将1#冷却室的铝料移至1#解垛位', N'DB100.0.0', N'Bool', 0, N'', 1, 2, N'1#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (39, N'加料车', 390, N'将1#冷却室的铝料移至2#解垛位', N'DB100.0.1', N'Bool', 0, N'', 1, 2, N'1#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (40, N'加料车', 400, N'将1#冷却室的铝料移至3#解垛位', N'DB100.0.2', N'Bool', 0, N'', 1, 2, N'1#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (41, N'加料车', 410, N'将2#冷却室的铝料移至1#解垛位', N'DB100.0.3', N'Bool', 0, N'', 1, 2, N'2#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (42, N'加料车', 420, N'将2#冷却室的铝料移至2#解垛位', N'DB100.0.4', N'Bool', 0, N'', 1, 2, N'2#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (43, N'加料车', 430, N'将2#冷却室的铝料移至3#解垛位', N'DB100.0.5', N'Bool', 0, N'', 1, 2, N'2#冷却室')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (44, N'加料车', 440, N'将1#均质炉的铝料移至1#冷却室', N'DB100.0.6', N'Bool', 0, N'', 1, 2, N'1#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (45, N'加料车', 450, N'将1#均质炉的铝料移至2#冷却室', N'DB100.0.7', N'Bool', 0, N'', 1, 2, N'1#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (46, N'加料车', 460, N'将2#均质炉的铝料移至1#冷却室', N'DB100.1.0', N'Bool', 0, N'', 1, 2, N'2#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (47, N'加料车', 470, N'将2#均质炉的铝料移至2#冷却室', N'DB100.1.1', N'Bool', 0, N'', 1, 2, N'2#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (48, N'加料车', 480, N'将3#均质炉的铝料移至1#冷却室', N'DB100.1.2', N'Bool', 0, N'', 1, 2, N'3#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (49, N'加料车', 490, N'将3#均质炉的铝料移至2#冷却室', N'DB100.1.3', N'Bool', 0, N'', 1, 2, N'3#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (50, N'加料车', 500, N'将4#均质炉的铝料移至1#冷却室', N'DB100.1.4', N'Bool', 0, N'', 1, 2, N'4#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (51, N'加料车', 510, N'将4#均质炉的铝料移至2#冷却室', N'DB100.1.5', N'Bool', 0, N'', 1, 2, N'4#均质炉')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (52, N'加料车', 520, N'将1#堆垛位的铝料移至1#均质炉', N'DB100.1.6', N'Bool', 0, N'', 1, 2, N'1#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (53, N'加料车', 530, N'将1#堆垛位的铝料移至2#均质炉', N'DB100.1.7', N'Bool', 0, N'', 1, 2, N'1#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (54, N'加料车', 540, N'将1#堆垛位的铝料移至3#均质炉', N'DB100.2.0', N'Bool', 0, N'', 1, 2, N'1#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (55, N'加料车', 550, N'将1#堆垛位的铝料移至4#均质炉', N'DB100.2.1', N'Bool', 0, N'', 1, 2, N'1#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (56, N'加料车', 560, N'将2#堆垛位的铝料移至1#均质炉', N'DB100.2.2', N'Bool', 0, N'', 1, 2, N'2#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (57, N'加料车', 570, N'将2#堆垛位的铝料移至2#均质炉', N'DB100.2.3', N'Bool', 0, N'', 1, 2, N'2#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (58, N'加料车', 580, N'将2#堆垛位的铝料移至3#均质炉', N'DB100.2.4', N'Bool', 0, N'', 1, 2, N'2#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (59, N'加料车', 590, N'将2#堆垛位的铝料移至4#均质炉', N'DB100.2.5', N'Bool', 0, N'', 1, 2, N'2#堆垛位')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (60, N'加料车', 600, N'将1#隔条仓的空隔条架子移至隔条总仓', N'DB100.2.6', N'Bool', 0, N'', 1, 2, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (61, N'加料车', 610, N'将3#隔条仓的隔条移至1#隔条仓', N'DB100.2.7', N'Bool', 0, N'', 1, 2, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (62, N'加料车', 620, N'将隔条总仓的空隔条架子移至3#隔条仓', N'DB100.3.0', N'Bool', 0, N'', 1, 2, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (63, N'加料车', 630, N'将2#隔条仓的空隔条架子移至隔条总仓', N'DB100.3.1', N'Bool', 0, N'', 1, 2, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (64, N'加料车', 640, N'将3#隔条仓的隔条移至2#隔条仓', N'DB100.3.2', N'Bool', 0, N'', 1, 2, N'3#隔条仓')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (65, N'加料车', 650, N'搬运1#解垛位底部隔条', N'DB100.3.3', N'Bool', 0, N'', 1, 2, N'1#解料垛')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (66, N'加料车', 660, N'搬运2#解垛位底部隔条', N'DB100.3.4', N'Bool', 0, N'', 1, 2, N'2#解料垛')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (67, N'加料车', 670, N'搬运3#解垛位底部隔条', N'DB100.3.5', N'Bool', 0, N'', 1, 2, N'3#解料垛')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (68, N'加料车', 680, N'控制系统确认任务完成', N'DB100.3.6', N'Bool', 0, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (69, N'加料车', 690, N'加料车待命', N'DB100.4.0', N'Bool', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (70, N'加料车', 700, N'加料车故障', N'DB100.4.1', N'Bool', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (71, N'加料车', 710, N'加料车暂停', N'DB100.4.2', N'Bool', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (72, N'加料车', 720, N'自动控制使能', N'DB100.4.3', N'Bool', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (73, N'加料车', 730, N'任务指令执行完成', N'DB100.4.5', N'Bool', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (74, N'加料车', 740, N'执行完成的标签名', N'DB100.262.0', N'String', 1, N'', 1, 3, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (75, N'加料车', 750, N'加料车在线', N'DB100.4.6', N'Bool', 1, N'', 1, 4, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (76, N'加料车', 760, N'加料车位置', N'DB100.272.0', N'DInt', 1, N'', 1, 5, N'加料车')
INSERT [dbo].[TagInfo] ([Id], [EquipmentName], [OrderNo], [TagDesc], [Address], [ValueType], [ReadOrWrite], [Remark], [IsEnable], [Type], [Point]) VALUES (77, N'加料车', 770, N'加料车回待机位待命', N'DB100.3.7', N'Bool', 0, N'', 1, 3, N'加料车')
SET IDENTITY_INSERT [dbo].[TagInfo] OFF
/****** Object:  Table [dbo].[ProgrammableLogicControllerConfig]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ProgrammableLogicControllerConfig](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[SiemensPlcAddress] [nvarchar](50) NULL,
 CONSTRAINT [PK_TestProgrammableLogicControllerConfig] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PLC地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProgrammableLogicControllerConfig', @level2type=N'COLUMN',@level2name=N'SiemensPlcAddress'

SET IDENTITY_INSERT [dbo].[ProgrammableLogicControllerConfig] ON
INSERT [dbo].[ProgrammableLogicControllerConfig] ([id], [SiemensPlcAddress]) VALUES (1, N'192.168.0.31')
SET IDENTITY_INSERT [dbo].[ProgrammableLogicControllerConfig] OFF
/****** Object:  Table [dbo].[PriorityConfig]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[PriorityConfig](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TagDesc] [varchar](100) NULL,
	[Priority] [varchar](30) NULL,
	[PriorityNo] [int] NULL,
	[TagType] [varchar](50) NULL,
 CONSTRAINT [PK_PriorityConfig] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PriorityConfig', @level2type=N'COLUMN',@level2name=N'Id'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外键：依赖标签表主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PriorityConfig', @level2type=N'COLUMN',@level2name=N'TagDesc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优先级：A、B、C、D、E、F、G等等' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PriorityConfig', @level2type=N'COLUMN',@level2name=N'Priority'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优先级内部序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PriorityConfig', @level2type=N'COLUMN',@level2name=N'PriorityNo'

SET IDENTITY_INSERT [dbo].[PriorityConfig] ON
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (1, N'1#冷却室冷却完成', N'A', 1, N'冷却室')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (2, N'2#冷却室冷却完成', N'A', 2, N'冷却室')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (3, N'1#均质炉加热完成', N'B', 1, N'均质炉')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (4, N'2#均质炉加热完成', N'B', 2, N'均质炉')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (5, N'3#均质炉加热完成', N'B', 3, N'均质炉')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (6, N'4#均质炉加热完成', N'B', 4, N'均质炉')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (7, N'1#堆垛位满', N'C', 1, N'堆垛位')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (8, N'2#堆垛位满', N'C', 2, N'堆垛位')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (9, N'3#隔条仓满', N'D', 1, N'隔条仓')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (10, N'1#解垛位仅剩隔条', N'E', 1, N'解垛位')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (11, N'2#解垛位仅剩隔条', N'E', 2, N'解垛位')
INSERT [dbo].[PriorityConfig] ([Id], [TagDesc], [Priority], [PriorityNo], [TagType]) VALUES (12, N'3#解垛位仅剩隔条', N'E', 3, N'解垛位')
SET IDENTITY_INSERT [dbo].[PriorityConfig] OFF
/****** Object:  Table [dbo].[Log]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[Log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OrderNo] [int] NULL,
	[UserName] [varchar](255) NULL,
	[OperName] [varchar](255) NULL,
	[OperContent] [varchar](1000) NULL,
	[OperTime] [datetime2](7) NULL,
	[OperIp] [varchar](255) NULL,
 CONSTRAINT [PK_Log] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_Log] UNIQUE NONCLUSTERED 
(
	[OrderNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'Id'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'OrderNo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'UserName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'OperName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'OperContent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'OperTime'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Log', @level2type=N'COLUMN',@level2name=N'OperIp'

/****** Object:  Table [dbo].[AluminumStackTagInfo]    Script Date: 07/30/2021 13:22:11 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[AluminumStackTagInfo](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TagDesc] [varchar](255) NULL,
	[Address] [varchar](255) NULL,
	[Equipment] [varchar](255) NULL,
	[Type] [varchar](255) NULL,
	[ValueType] [varchar](255) NULL,
	[LevelNum] [int] NULL,
 CONSTRAINT [PK_AluminumStackTagInfo] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'Id'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'程序块描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'TagDesc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'Address'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属设备' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'Equipment'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据类型：棒径、等等' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'值类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'ValueType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo', @level2type=N'COLUMN',@level2name=N'LevelNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'铝垛程序块信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AluminumStackTagInfo'

SET IDENTITY_INSERT [dbo].[AluminumStackTagInfo] ON
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (127, N'铝垛堆叠层数', N'DB2.14.0', N'1#堆垛位', N'层数', N'DInt', NULL)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (128, N'第一层数量', N'DB2.86.0', N'1#堆垛位', N'数量', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (129, N'第二层数量', N'DB2.88.0', N'1#堆垛位', N'数量', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (130, N'第三层数量', N'DB2.90.0', N'1#堆垛位', N'数量', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (131, N'第四层数量', N'DB2.92.0', N'1#堆垛位', N'数量', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (132, N'第五层数量', N'DB2.94.0', N'1#堆垛位', N'数量', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (133, N'第六层数量', N'DB2.96.0', N'1#堆垛位', N'数量', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (134, N'第七层数量', N'DB2.98.0', N'1#堆垛位', N'数量', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (135, N'第八层数量', N'DB2.100.0', N'1#堆垛位', N'数量', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (136, N'第九层数量', N'DB2.102.0', N'1#堆垛位', N'数量', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (137, N'第十层数量', N'DB2.104.0', N'1#堆垛位', N'数量', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (138, N'第一层铝棒直径', N'DB2.42.0', N'1#堆垛位', N'棒径', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (139, N'第二层铝棒直径', N'DB2.44.0', N'1#堆垛位', N'棒径', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (140, N'第三层铝棒直径', N'DB2.46.0', N'1#堆垛位', N'棒径', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (141, N'第四层铝棒直径', N'DB2.48.0', N'1#堆垛位', N'棒径', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (142, N'第五层铝棒直径', N'DB2.50.0', N'1#堆垛位', N'棒径', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (143, N'第六层铝棒直径', N'DB2.52.0', N'1#堆垛位', N'棒径', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (144, N'第七层铝棒直径', N'DB2.54.0', N'1#堆垛位', N'棒径', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (145, N'第八层铝棒直径', N'DB2.56.0', N'1#堆垛位', N'棒径', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (146, N'第九层铝棒直径', N'DB2.58.0', N'1#堆垛位', N'棒径', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (147, N'第十层铝棒直径', N'DB2.60.0', N'1#堆垛位', N'棒径', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (148, N'铝垛堆叠层数', N'DB2.20.0', N'2#堆垛位', N'层数', N'DInt', NULL)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (149, N'第一层数量', N'DB2.152.0', N'2#堆垛位', N'数量', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (150, N'第二层数量', N'DB2.154.0', N'2#堆垛位', N'数量', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (151, N'第三层数量', N'DB2.156.0', N'2#堆垛位', N'数量', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (152, N'第四层数量', N'DB2.158.0', N'2#堆垛位', N'数量', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (153, N'第五层数量', N'DB2.160.0', N'2#堆垛位', N'数量', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (154, N'第六层数量', N'DB2.162.0', N'2#堆垛位', N'数量', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (155, N'第七层数量', N'DB2.164.0', N'2#堆垛位', N'数量', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (156, N'第八层数量', N'DB2.166.0', N'2#堆垛位', N'数量', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (157, N'第九层数量', N'DB2.168.0', N'2#堆垛位', N'数量', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (158, N'第十层数量', N'DB2.170.0', N'2#堆垛位', N'数量', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (159, N'第一层铝棒直径', N'DB2.108.0', N'2#堆垛位', N'棒径', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (160, N'第二层铝棒直径', N'DB2.110.0', N'2#堆垛位', N'棒径', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (161, N'第三层铝棒直径', N'DB2.112.0', N'2#堆垛位', N'棒径', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (162, N'第四层铝棒直径', N'DB2.114.0', N'2#堆垛位', N'棒径', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (163, N'第五层铝棒直径', N'DB2.116.0', N'2#堆垛位', N'棒径', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (164, N'第六层铝棒直径', N'DB2.118.0', N'2#堆垛位', N'棒径', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (165, N'第七层铝棒直径', N'DB2.120.0', N'2#堆垛位', N'棒径', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (166, N'第八层铝棒直径', N'DB2.122.0', N'2#堆垛位', N'棒径', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (167, N'第九层铝棒直径', N'DB2.124.0', N'2#堆垛位', N'棒径', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (168, N'第十层铝棒直径', N'DB2.126.0', N'2#堆垛位', N'棒径', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (169, N'铝垛堆叠层数', N'DB2.240', N'1#解垛位', N'层数', N'DInt', NULL)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (171, N'第一层数量', N'DB2.218', N'1#解垛位', N'数量', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (172, N'第二层数量', N'DB2.220', N'1#解垛位', N'数量', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (173, N'第三层数量', N'DB2.222', N'1#解垛位', N'数量', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (174, N'第四层数量', N'DB2.224', N'1#解垛位', N'数量', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (175, N'第五层数量', N'DB2.226', N'1#解垛位', N'数量', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (176, N'第六层数量', N'DB2.228', N'1#解垛位', N'数量', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (177, N'第七层数量', N'DB2.230', N'1#解垛位', N'数量', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (178, N'第八层数量', N'DB2.232', N'1#解垛位', N'数量', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (179, N'第九层数量', N'DB2.234', N'1#解垛位', N'数量', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (180, N'第十层数量', N'DB2.236', N'1#解垛位', N'数量', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (181, N'第一层铝棒直径', N'DB2.174.0', N'1#解垛位', N'棒径', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (182, N'第二层铝棒直径', N'DB2.176.0', N'1#解垛位', N'棒径', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (183, N'第三层铝棒直径', N'DB2.178.0', N'1#解垛位', N'棒径', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (184, N'第四层铝棒直径', N'DB2.180.0', N'1#解垛位', N'棒径', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (185, N'第五层铝棒直径', N'DB2.182.0', N'1#解垛位', N'棒径', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (186, N'第六层铝棒直径', N'DB2.184.0', N'1#解垛位', N'棒径', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (187, N'第七层铝棒直径', N'DB2.186.0', N'1#解垛位', N'棒径', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (188, N'第八层铝棒直径', N'DB2.188.0', N'1#解垛位', N'棒径', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (189, N'第九层铝棒直径', N'DB2.190.0', N'1#解垛位', N'棒径', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (190, N'第十层铝棒直径', N'DB2.192.0', N'1#解垛位', N'棒径', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (191, N'铝垛堆叠层数', N'DB2.310', N'2#解垛位', N'层数', N'DInt', NULL)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (192, N'第一层数量', N'DB2.288.0', N'2#解垛位', N'数量', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (193, N'第二层数量', N'DB2.290.0', N'2#解垛位', N'数量', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (194, N'第三层数量', N'DB2.292.0', N'2#解垛位', N'数量', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (195, N'第四层数量', N'DB2.294.0', N'2#解垛位', N'数量', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (196, N'第五层数量', N'DB2.296.0', N'2#解垛位', N'数量', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (197, N'第六层数量', N'DB2.298.0', N'2#解垛位', N'数量', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (198, N'第七层数量', N'DB2.300.0', N'2#解垛位', N'数量', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (199, N'第八层数量', N'DB2.302.0', N'2#解垛位', N'数量', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (200, N'第九层数量', N'DB2.304.0', N'2#解垛位', N'数量', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (201, N'第十层数量', N'DB2.306.0', N'2#解垛位', N'数量', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (202, N'第一层铝棒直径', N'DB2.244.0', N'2#解垛位', N'棒径', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (203, N'第二层铝棒直径', N'DB2.246.0', N'2#解垛位', N'棒径', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (204, N'第三层铝棒直径', N'DB2.248.0', N'2#解垛位', N'棒径', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (205, N'第四层铝棒直径', N'DB2.250.0', N'2#解垛位', N'棒径', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (206, N'第五层铝棒直径', N'DB2.252.0', N'2#解垛位', N'棒径', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (207, N'第六层铝棒直径', N'DB2.254.0', N'2#解垛位', N'棒径', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (208, N'第七层铝棒直径', N'DB2.256.0', N'2#解垛位', N'棒径', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (209, N'第八层铝棒直径', N'DB2.258.0', N'2#解垛位', N'棒径', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (210, N'第九层铝棒直径', N'DB2.260.0', N'2#解垛位', N'棒径', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (211, N'第十层铝棒直径', N'DB2.262.0', N'2#解垛位', N'棒径', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (212, N'铝垛堆叠层数', N'DB2.380', N'3#解垛位', N'层数', N'DInt', NULL)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (213, N'第一层数量', N'DB2.358.0', N'3#解垛位', N'数量', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (214, N'第二层数量', N'DB2.360.0', N'3#解垛位', N'数量', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (215, N'第三层数量', N'DB2.362.0', N'3#解垛位', N'数量', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (216, N'第四层数量', N'DB2.364.0', N'3#解垛位', N'数量', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (217, N'第五层数量', N'DB2.366.0', N'3#解垛位', N'数量', N'Int', 5)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (218, N'第六层数量', N'DB2.368.0', N'3#解垛位', N'数量', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (219, N'第七层数量', N'DB2.370.0', N'3#解垛位', N'数量', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (220, N'第八层数量', N'DB2.372.0', N'3#解垛位', N'数量', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (221, N'第九层数量', N'DB2.374.0', N'3#解垛位', N'数量', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (222, N'第十层数量', N'DB2.378.0', N'3#解垛位', N'数量', N'Int', 10)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (223, N'第一层铝棒直径', N'DB2.314.0', N'3#解垛位', N'棒径', N'Int', 1)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (224, N'第二层铝棒直径', N'DB2.316.0', N'3#解垛位', N'棒径', N'Int', 2)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (225, N'第三层铝棒直径', N'DB2.318.0', N'3#解垛位', N'棒径', N'Int', 3)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (226, N'第四层铝棒直径', N'DB2.320.0', N'3#解垛位', N'棒径', N'Int', 4)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (227, N'第五层铝棒直径', N'DB2.322.0', N'3#解垛位', N'棒径', N'Int', 5)

print 'Processed 100 total records'
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (228, N'第六层铝棒直径', N'DB2.324.0', N'3#解垛位', N'棒径', N'Int', 6)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (229, N'第七层铝棒直径', N'DB2.326.0', N'3#解垛位', N'棒径', N'Int', 7)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (230, N'第八层铝棒直径', N'DB2.328.0', N'3#解垛位', N'棒径', N'Int', 8)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (231, N'第九层铝棒直径', N'DB2.330.0', N'3#解垛位', N'棒径', N'Int', 9)
INSERT [dbo].[AluminumStackTagInfo] ([Id], [TagDesc], [Address], [Equipment], [Type], [ValueType], [LevelNum]) VALUES (232, N'第十层铝棒直径', N'DB2.332.0', N'3#解垛位', N'棒径', N'Int', 10)
SET IDENTITY_INSERT [dbo].[AluminumStackTagInfo] OFF
/****** Object:  Default [DF_Table_1_isDelete]    Script Date: 07/30/2021 13:22:11 ******/
ALTER TABLE [dbo].[TagInfo] ADD  CONSTRAINT [DF_Table_1_isDelete]  DEFAULT ((0)) FOR [ReadOrWrite]

/****** Object:  ForeignKey [FK_PriorityConfig_PriorityConfig]    Script Date: 07/30/2021 13:22:11 ******/
ALTER TABLE [dbo].[PriorityConfig]  WITH CHECK ADD  CONSTRAINT [FK_PriorityConfig_PriorityConfig] FOREIGN KEY([Id])
REFERENCES [dbo].[PriorityConfig] ([Id])

ALTER TABLE [dbo].[PriorityConfig] CHECK CONSTRAINT [FK_PriorityConfig_PriorityConfig]

